package me.zhengjie.modules.finace_taxation.service.mapper;

import me.zhengjie.base.CommonMapper;
import me.zhengjie.modules.finace_taxation.domain.FtContactUs;
import me.zhengjie.modules.finace_taxation.service.dto.FtContactUsDto;
import me.zhengjie.modules.finace_taxation.service.dto.FtContactUsQueryParam;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
* @author 杨荣森
* @date 2021-06-22
*/
@Repository
public interface FtContactUsMapper extends CommonMapper<FtContactUs> {

    /*查询城市下公司的联系方式*/
    @Select("select * from ft_contact_us where company_city = #{companyCity} or ISNULL(company_city)")
    List<FtContactUs> getContactUsByCity(FtContactUsQueryParam queryParam);
}
